ALTER PROCEDURE [dbo].[Delete_results] @file_No INT 
AS 
  BEGIN 
      DELETE FROM dbo.dvip_out_bio_milkyield_data 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_out_bio_sell_data 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_out_del_data 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_out_ins_data 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_out_pol_data 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_out_result 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_out_rpo_data 
      WHERE  file_no = @file_No; 

  END 